package com.ztman.service.work.dao;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ztman.basic.base.mapper.SuperMapper;
import com.ztman.service.work.dto.WorkOrderInfoPageQuery;
import com.ztman.service.work.entity.WorkOrderInfo;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import org.springframework.web.bind.annotation.PathVariable;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * Mapper 接口
 *
 * </p>
 *
 * @author wsd
 * @date 2021-08-23
 */
@Repository
public interface WorkOrderInfoMapper extends SuperMapper<WorkOrderInfo> {

    IPage<WorkOrderInfoPageQuery> pageType(IPage<Object> page,@Param("query") WorkOrderInfoPageQuery model);

    WorkOrderInfo getWorkOrderInfoById(@Param("id") Long work_order_id);

    List<Map<String, Object>> workOrderRank(@Param("startTime") Date date0000, @Param("endTime") Date date2359);

    List<Map<String, Object>>  DateRangeStatistics(@Param("startTime") Date date0000,@Param("endTime") Date date2359);

    List<Map<String, Object>>  HandlePersonRank(@Param("startTime") Date date0000,@Param("endTime") Date date2359);

    List<Map<String, Object>>  HandlePeriodRank(@Param("startTime") Date date0000,@Param("endTime") Date date2359);
}
